﻿CREATE TABLE [fb].[Person] (
    [CounterpartyId] INT            NOT NULL,
    [FirstName]      NVARCHAR (200) NOT NULL,
    [LastName]       NVARCHAR (200) NULL,
    CONSTRAINT [PK_fb.Person] PRIMARY KEY CLUSTERED ([CounterpartyId] ASC),
    CONSTRAINT [FK_fb.Person_fb.Counterparty_CounterpartyId] FOREIGN KEY ([CounterpartyId]) REFERENCES [fb].[Counterparty] ([CounterpartyId])
);


GO
CREATE NONCLUSTERED INDEX [IX_CounterpartyId]
    ON [fb].[Person]([CounterpartyId] ASC);

